Magnum One

home *** CD-ROM | disk | FTP | other *** search

/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d6 / dyobo13.arc / DAYOBO.DOC < prev next >

Wrap

Text File | 1990-10-15 | 150KB | 2,561 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █▄████▄ ▄█████▄ ║ ║ █▒░ █▒░ █▒░ █▒░ ║ ║ █▒░ █▒░ █▒░ █▒░ ║ ║ █▄▄▄▄█▀ █▒░ █▒░ ║ ║ █▒░ ▀█▒░ █▒░ █▒░ ║ ║ █▒░ █▒░ █▒░ █▒░ ║ ║ █▀████▀ ▀█████▀ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ BACK ORDERS ║ ║ ║ ║ MAINTENANCE MODULE FOR CUSTOMER'S UNFILLED ORDERS ║ ║ ║ ║ ║ ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║ ║ ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO BO, TJS LAB Orlando, Florida "Try before you buy..." ┌─────────┐ ┌─────┴───┐ │ (tm) ──│ │o │────────────────── │ ┌─────┴╨──┐ │ Association of │ │ │─┘ Shareware └───│ o │ Professionals ──────│ ║ │──────────────────── └────╨────┘ MEMBER This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products. Please write to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a Compuserve message via easyplex to ASP Ombudsman 70007,3536 ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 1 year after date of registration or upgrade. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO BO, TJS LAB Page: 1 Table of Contents Page Subject ──── ─────────────────────────────────────── 3 ............... INTRODUCTION 4 ............... COPYRIGHT/LICENSE 4 ............... DISCLAIMER 4 ............... REQUIREMENTS 4 ............... SETUP 5 ............... MAIN MENU 5 ............... PASSWORD/NAME 6 ............... OPEN REGISTER 7 ............... CREATING ADDITIONAL REGISTERS 7 ............... CLOSE REGISTER 8 ............... ALLOCATION 8 ............... ALLOCATE SCREEN 9 ............... ALLOCATION PROCESS 10 ............... BACK ORDER BROWSE 10 ............... HELP - F1 11 ............... FULL SCREEN EDIT - F2 11 ............... INVOICE - F3 12 ............... FINAL EDIT SCREEN 12 ............... MULTIPLE SHIPTOS 13 ............... TYPE, TERMS, SHIPPER, TAXCODE/TAXRATES 13 ............... ENTER RECEIPT AMOUNT 14 ............... EXIT/FINISH 14 ............... WORK ORDER NOTES/COMMENTS 15 ............... DATABASE POSTING 16 ............... ADD BO RECORD 16 ............... DELETE BO RECORD 16 ............... FIND (F5/F6/F7/F8) 17 ............... CUSTOMERS 17 ............... FIND (F5/F6/F7/F8) 18 ............... CONFIGURATION 18 ............... CONFIGURATION MENU 19 ............... COMPANY NAME, ADDRESS & TELEPHONE 19 ............... AUTOMATICALLY PRINT THE INVOICE 20 ............... AUTOMATIC ALLOCATION 20 ............... LAST INVOICE NUMBER 20 ............... INVOICE PRINTER TYPE 20 ............... INVOICE PRINTER PORT 20 ............... INVOICE COPIES 21 ............... ALLOW BROWSE EDITING 21 ............... USE CREDIT LIMIT 21 ............... INVENTORY DATABASE LOCATION 21 ............... CUSTOMER DATABASE LOCATION 22 ............... POS DATABASE LOCATION 22 ............... CASH DRAWER 22 ............... CASH DRAWER SERIAL PORT 22 ............... PARALLEL CASH DRAWER 23 ............... PARALLEL CASH DRAWER PORT 23 ............... PARALLEL CASH DRAWER SETUP CODE DAYO BO, TJS LAB Page: 2 Table of Contents Page Subject ──── ─────────────────────────────────────── 23 ............... REPORT PRINTER TYPE 23 ............... REPORT PRINTER PORT 23 ............... VISUAL INDEXING 24 ............... AUTOMATIC DAILY INDEXING 24 ............... AUTO PRINT PACKING LIST 24 ............... PACKING LIST PRINTER PORT 24 ............... PRINT PRICE ON PACKING LIST 25 ............... COLOR MONITOR 25 ............... COLOR INTENSITY 26 ............... REPORTS 27 ............... ALLOCATION REPORT 27 ............... BACK ORDER REPORT 28 ............... INVENTORY BACKORDER RESET & REPORT 28 ............... CUSTOMER SHIP TO ADDRESS LABELS 29 ............... DATABASE STATUS REPORT 30 ............... CONFIGURATION STATUS REPORT 31 ............... AN EXAMPLE OF A CONFIGURATION STATUS REPORT 34 ............... PRINTER DRIVER (SETUP) 34 ............... PRINTER DRIVER OPTIONS 35 ............... CHANGE DEFAULT PRINTER 36 ............... FULL SCREEN EDIT - F2 36 ............... PRINTER DRIVER DATABASE FIELD DEFINITIONS 37 ............... HELP SCREENS 38 ............... EXPANDED HELP 39 ............... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 40 ............... VIEW DOCUMENTATION ONSCREEN 41 ............... DATABASE STRUCTURE 46 ............... DATA DICTIONARY 50 ............... DAYO BO MAINTENANCE & QUIRKS 52 ............... TJS LAB, CUSTOM CODING DAYO BO, TJS LAB Page: 3 ■ INTRODUCTION DAYO BO (BackOrder), is the maintenance module for customer's unfilled orders. BackOrders are created with the POS module just like you would an invoice. All invoice items not onhand in the inventory become a BackOrder. As products/items are received into your inventory, the BackOrder Allocation process is run to fill your BackOrders. BackOrders are filled, 'first come, first serve', based on the date and time of the original order. The Allocation process has 2 modes of operation: AUTO or VERIFY. DAYO BO is totally integrated with the DAYO POS and DAYO Inventory modules. Like all DAYO applications, DAYO BO is multiuser when used on a PC based LAN/Network. It can, however be run as a 'standalone' application. Some of the DAYO BO highlights are: Multiuser (ie: Novell) Registers Work Orders Allocation Process BackOrder Reset Cash Drawers Databases are dBase (tm) compatible HP Laser Special Invoices Preprinted Invoices Standard Invoices Packing/Shipping Lists Customer Ship To/Mailing Address Labels 24 Configuration Settings Credit Limits Passwords (with DAYO Passwords) Reports Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sale DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYO EOP End Of Period Posting DAYO Passwords Password protect your DAYO system DAYO Smart Reports A variety of reports pertaining to the above modules DAYOX Network/LAN Index Maintenance Utility DAYO BO, TJS LAB Page: 4 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO BO software, documentation, and source codes. Read the Order Form (last page), for more information on Source Codes... Authorization to distribute the Shareware Version (unregistered) is granted. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware and/or software systems as a result of using DAYO BO. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO BO, copy the contents of the DAYO BO floppy disks into a directory on your hard disk (ie: \DAYOBO). If this is the Shareware Version, you need to UnZip/UnArc the files here. When you run DAYOBO for the first time, it will create all the database, index, and configuration files it requires for operation. If you are using other DAYO modules, be sure to enter the location of these databases into the DAYO BO configuration. Type and enter 'DAYOO' at the DOS prompt to run the program (ie: C:\DAYOO ). DAYO BO, TJS LAB Page: 5 ■ MAIN MENU After a few moments and possibly a reindex, the main menu will appear: DAYOBO V1.3, TJS LAB ┌─────[July 1990]────┐ │S M T W T F S │ ╓─────────────────────────╖ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ║ 1 REGISTER ║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ╟─────────────────────────╢ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ 2 ALLOCATE ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ╟─────────────────────────╢ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ 3 BROWSE ║ ████▀ █░ █░ █░ ▀███▀ │29 30 31 │ ╟─────────────────────────╢ │ │ ║ 4 CUSTOMERS ║ └────────────────────┘ ╟─────────────────────────╢ ║ 5 CONFIGURATION ║ ╟─────────────────────────╢╓────────────────────────────────────────────────╖ ║ 6 REPORTS ║║ DAYO BO STATISTICS Register Open ║ ╟─────────────────────────╢╟────────────────────────────────────────────────╢ ║ 7 EXIT ║║ DATABASE NAME RECORDS SIZE ║ ╚═════════════════════════╝╟────────────────────────────────────────────────╢ Select Option ║ INV.DBF Inventory 5 2K ║ █▄███▄ ▄████▄ ║ INVOICE.DBF Invoice Header 77 30K ║ █░ █░ █░ █░ ║ DETAIL.DBF Invoice Detail 166 16K ║ █▄▄▄█▀ █░ █░ ║ BACKORDER.DBF BackOrders 22 3K ║ █░ ▀█░ █░ █░ ║ CUSTOMER.DBF Customers 217 95K ║ █░ █░ █░ █░ ║ REGISTER.LOG Register Log 753 66K ║ █▀███▀ ▀████▀ ╚════════════════════════════════════════════════╝ Open, ReOpen, or Close Your Register The left side of the screen is the actual main menu. The calendar and logos are just 'art'. The DAYO BO STATISTICS box (bottom right) contains the number of records and size (in kilo bytes) of the main databases (there are many others!). ■ PASSWORD/NAME From the main menu you can enter any of the modules, but not until you enter your name (or password if using DAYO Password): ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: TOM JOHNSON ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 6 ■ OPEN REGISTER Before you can enter the ALLOCATE or the BROWSE options, you must open/reopen a register. Opening a register means the recording of the amount of money you start the day (period) with. Subsequent invoices will be 'posted' to this register thus creating a reliable means of auditing your daily sales. You are required to close this register at the end of day (or period). It is recommended (and common sense), that you reconcile your register at this time. Note there are various Register Reports that can aid you in your audit. These reports are found in the DAYO POS module. To open a register, select the REGISTER option from the main menu. You will then be prompted to open (or reopen), a register. ┌───────────────────[ OPEN/CLOSE REGISTER ]──────────────┐ │ │ │ Select the Register you wish to Open, Re-open, or │ │ Close. You can not create an invoice unless you │ │ open a Register first! │ │ Select Register to OPEN/RE-OPEN/CLOSE... │ │ │ │ Register Open Open Date Close Date Start $ │ │──────────╥──────╥───────────╥────────────╥─────────────│ │ 1 ║ F ║ 12/28/89 ║ 12/28/89 ║ 100.00 │ │ 2 ║ T ║ 12/26/89 ║ / / ║ 0.00 │ │ ║ ║ ║ ║ │ └────────────────────────────────────────────────────────┘ DAYO BO starts off with only one register (1), but you can create others. Note, it is recommended that DAYO BO use the same REGISTER.DBF as does DAYO POS. This is accomplished by insuring that the Configuration setting for the POS Database Location is correctly entered. You can have many registers, but you can not open a register on more than one machine at a time. When you open the register, it prompts you to enter the amount of money you wish to start the day with. ┌─────────────────────[ OPEN REGISTER 1 ]────────────────┐ │ │ │ Select the Register you wish to Open, Re-open, or │ │ Close. You can not create an invoice unless you │ │ open a Register first! │ │ Select Register to OPEN/RE-OPEN/CLOSE... │ │ │ │ │ │ │ │ Enter Starting Register Amount: 100.00 │ │ [ Press Esc to Abort ] │ │ │ └────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 7 When a register is opened/reopened, the file is 'locked'. This prevents another machine/CPU from opening it. ■ CREATING ADDITIONAL REGISTERS To create additional registers, go into the MISC ROUTINES of the DAYO POS module, and select the BROWSE DATABASES option. At the prompt for database, just press Enter/Return to bring up a list of the databases in the current directory. Select the REGISTER.DBF. Press 'Ctrl N' simultaneously to add another record. The record number of that new record becomes the new register number. ■ CLOSE REGISTER At the end of the day or period, you need to close the register. Do this by entering the REGISTER option off the main menu. You will be given a a prompt to input the amount of money in the register/cash drawer. ┌───────────────────[ CLOSE REGISTER 1 ]─────────────────┐ │ │ │ Select the Register you wish to Open, Re-open, or │ │ Close. You can not create an invoice unless you │ │ open a Register first! │ │ │ │ │ │ │ │ │ │ Enter Ending Register Amount: 10493.00 │ │ [ Press Esc to Abort ] │ │ │ └────────────────────────────────────────────────────────┘ After entering your closing balance, a window will appear letting you know the differences (if any), between what you ended with, and what the register calculates you should have (starting amount plus received payments amount). ┌───────────────────────────────────┐ │ │ │ Started With: 23.10 │ │ Ended With: 123.10 │ │ Difference: 100.00 │ │ Invoice Receipts: 100.11 │ │ ────────────────- ─────────- │ │ Variance: -.11 │ └───────────────────────────────────┘ DAYO BO, TJS LAB Page: 8 ■ ALLOCATION To complete your BackOrders, you must first fill them. You can use the Allocation process (option 2 from the main menu), or 'manually' fill orders by editing the field FILLED in the BackOrder Browse (option 3 from the main menu). The Allocation process takes the BackOrders (in the order they were created 'first in, first out') and updates the FILLED field with ONHAND quantity from the inventory database (INV.DBF). ■ ALLOCATE SCREEN The option to reset the backorder quantity in the inventory database is before starting the Allocation process is presented upon initial entry into this routine. The backorder quantity (BO field) will be reset only for those items found to be backordered. If you decide to reset the backorder (BO) field, a progress graph will be displayed. DAYOBO V1.3, TJS LAB ALLOCATE Back Order ▄█▄ █░ █░ ▄██▄ ▄██▄ ▄█▄ ▄███▄ ▀█▀ ▄██▄ ██░ █░ █░█░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █▀█░█░ ▄███▄ █░ █░ █░ █░ █░ ▄███▄ █░ █░ █░ █░ █░▀██░ █░ █░ ███░ ███░ ▀██▀ ▀██▀ █░ █░ █░ ▄█▄ ▀██▀ █░ ▀█░ Do you wish to Zero the backorder quantity field (BO) in the inventory database (INV.DBF)? (Y/N) * ╔═════════════════════════════════════╤═════════════════════════════════════╗ ╟████████████████████████████████████████─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─╢ ╚═════════════════════════════════════╧═════════════════════════════════════╝ 0% 50% Finis DAYO BO, TJS LAB Page: 9 ■ ALLOCATION PROCESS The progress of the Allocation process is displayed with a graph and a scroll of all items filled. The total value of the backorders and the total value of the filled backorders is displayed at the bottom of the screen. DAYOBO V1.3, TJS LAB ALLOCATE Back Order ▄█▄ █░ █░ ▄██▄ ▄██▄ ▄█▄ ▄███▄ ▀█▀ ▄██▄ ██░ █░ █░█░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ █▀█░█░ ▄███▄ █░ █░ █░ █░ █░ ▄███▄ █░ █░ █░ █░ █░▀██░ █░ █░ ███░ ███░ ▀██▀ ▀██▀ █░ █░ █░ ▄█▄ ▀██▀ █░ ▀█░ Starting the Allocation Process Updating the filled (FILLED) field in database BO.DBF ITEM DESCRIPTION INVOICE CUSTOMER ORDERED FILLED 102939-343 Red Velvet 10950 342300 4 0 102939-344 Yellow Velvet 10950 342300 2 0 ╔═════════════════════════════════════╤═════════════════════════════════════╗ ╟████████████████████████████████████████─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─╢ ╚═════════════════════════════════════╧═════════════════════════════════════╝ 0% Total $ BackOrdered: 17999.00 50% Total $ Filled: 288.00 Finis DAYO BO, TJS LAB Page: 10 ■ BACK ORDER BROWSE The BO Browse routine allows access to the BackOrder database (BO.DBF) so that you can view and/or edit the BO line items. It is from here that you will also print the Invoices and/or Work Orders for the backorders. Key information relating to the currently highlighted record is displayed onto screen: DAYOBO V1.3, TJS LAB BO BROWSE ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ Joe Smith Automobiles Joe Smith Automobiles ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 342300 REG NET 30 TRUCK ║ ║ PHONE ATTN CREDIT LASTDATE ║ ║ 40673.50 07/13/90 ║ ║ INVOICE DATE TIME PAID TAXABLE TERMS ║ ║ 10950 05/08/90 No Yes/0.0170 NET 30 ║ ║ ITEM DESCRIPTION QTY PRICE COST ║ ║ 102939-343 Red Velvet 4 5.00 3.02 ║ ║ AVAILABLE ONHAND ON ORDER TOTAL BO ║ ║ 3 12 4 9 ║ ╚════════════════════════════════════════════════════════════════════════════╝ INVOICE ITEM DESC QTY FILLED ─────────╥──────────────╥────────────────────────────────╥─────────╥────────── 10950 ║ 102939-343 ║ Red Velvet ║ 4 ║ 0 10951 ║ 102939-344 ║ Yellow Velvet ║ 2 ║ 0 10952 ║ 102939-345 ║ Green Velvet ║ 4 ║ 0 10953 ║ 102939-346 ║ White Velvet ║ 8 ║ 5 10954 ║ 102939-347 ║ Hollow White Velvet ║ 4 ║ 0 10955 ║ 102939-348 ║ Purple Orange Velvet ║ 4 ║ 0 Esc (Exit) F1 (Help) F2 (Edit) F3 (Invc) Ctrl N (Add) Ctrl U (Del) Find: F5 (Original Invoice) F6 (Item) F7 (Date) F8 (Item+Date) ■ HELP - F1 Press F1 to view what the special keys are while in a BROWSE. More on HELP later in this document... DAYO BO, TJS LAB Page: 11 ■ FULL SCREEN EDIT - F2 If the 'Allow Browse Editing' Configuration setting is set to 'Y', then you can edit any field while in the browse, or by pressing the F2 key. The Full Screen option will allow you to edit in a more traditional format. Note, no data validation takes place in BO Browse. DAYOBO V1.3, TJS LAB BO BROWSE ┌─────────────────────────────[ FULL SCREEN EDIT ]───────────────────────────┐ │ INVOICE: 12305 │ │ ITEM: 102000-HIGA │ │ DESC: TACTICAL INFORMATION SYSTEM │ │ QTY: 35 │ │ PRICE: 21000.00 │ │ COST: 15600.18 │ │ TAXABLE: T │ │ DATE: 01/14/90 │ │ PAY: F │ │ TIME: 13:49:00 │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ INVOICE - F3 Press F3 when you wish to print an Invoice or Work Order. There must exist quantity in the filled field (FILLED) or you can not print either. A beep and a message will appear on the bottom of the screen reminding you... DAYO BO, TJS LAB Page: 12 ■ FINAL EDIT SCREEN If there are filled items, the following screen will be displayed: DAYOBO V1.3, TJS LAB BO BROWSE Customer Number 342300 Bill To Name Joe Smith Automobiles Edit/Alter Invoice Header Ship To Name Joe Smith Automobiles Address 1 3800 East River Road Address 2 City Augusta State GA Zip 30909 Phone Type REG Terms NET 30 Shipper TRUCK Sales Person KKP Tax Rate 0.0500 Customer PO ABC-100001 Adjustment 10.00 Freight 3.00 Amount Paid 0.00 Taxes 0.00 Detail Subtotal 288.00 Comment Original Invoice:10950 SSC Esc (Exit) Enter/Return (Edit/Alter) If any field or value needs to be changed, then highlight it and then press enter/return. ■ MULTIPLE SHIPTOS If any Ship Tos exist (other than the one on the customer's record), a selection box of all other ShipTos will appear onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Select the Ship To Address & Data ║ ╠════════════════════════════════════════════════════════════════════════════╣ ║1 Joe Smith Autos, Site #1 1209 East River Road, Augusta GA 30902 ║ ║2 Joe Smith Autos, Site #2 PO Box 450023 West Madison Harper Va 90102 ║ ║3 Joe Smith Autos, Site #3 30 Harver Street North Augusta SC 29841 ║ ║4 Joe Smith Autos, Site #4 5002 Senic Lake Road Winter Park FL 39392 ║ ║5 Joe Smith Automobiles, #5 (PICKUP) ║ ║6 Joe Smith (Home) 1985 Lincoln Heights Pomeroy Ohio 89130 ║ ║7 *** Create New ShipTo *** ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO BO, TJS LAB Page: 13 ■ TYPE, TERMS, SHIPPER, TAXCODE/TAXRATES The 'Type', 'Terms', 'Shipper', and 'Tax Rate' fields will bring up a list of only the valid choices, ie: TYPE: TERMS: ┌─────────────────────────────────────┐ ┌────────────────────┐ │ Select Type │ │ Select Terms │ │REG - REGULAR SALE │ │COD │ │Ret - RETURN │ │CASH │ │Ref - REFUND │ │MASTERCARD │ │SPC - SPECIAL │ │VISA │ │LON - LOANED │ │DISCOVER │ │EXC - EXCHANGE │ │NET 7 │ │TRN - TRANSFER │ │NET 10 │ │VOD - VOIDED │ │NET 15 │ │DIR - DIRECT SHIPMENT │ │NET 30 │ └─────────────────────────────────────┘ │NET 60 │ └────────────────────┘ SHIPPER: ┌────────────────────┐ │ Select Shipper │ │DELIVER │ TAXCODE/TAXRATE: │UPS GROUND │ ┌──────────────────┐ │UPS BLUE │ │ Select Tax Rate │ │UPS RED │ │0 - 0.0000 │ │AIRBORNE │ │1 - 0.0600 │ │FEDERAL EXPRESS │ │2 - 0.0625 │ │TRUCK │ └──────────────────┘ │SPECIAL DELIVERY │ │US MAIL │ │PICKUP │ └────────────────────┘ ■ ENTER RECEIPT AMOUNT If any money is to be received, press enter/return on the 'Amount Paid' prompt, ie: ╔═══════════════════════════════════╗ ║ Receive From Customer: 301.00 ║ ╚═══════════════════════════════════╝ DAYO BO, TJS LAB Page: 14 ■ EXIT/FINISH Press Esc once when finished with editing the header record. If the customer has exceeded his credit limit (option set from configuration), not found, or is marked Not Active (ACTIVE) in the customer database (CUSTOMER.DBF), the following will be displayed: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Amount Due: 0.00 ║ ║ Amount Due this Invoice: 301.00 ║ ║ Subtotal: 301.00 ║ ║ Credit Limit: 0.00 ║ ║ ║ ║ Customer NOT ACTIVE! ║ ║ ║ ║ Press any key to continue... ║ ╚════════════════════════════════════════════════════════════════════════════╝ Finally the following display will appear prompting you to print an Invoice, Work Order, Redo the header record, or Abort: ╔══════════════════════════════════════╗ ║ Order Total: 288.00 ║ ║ ║ ║ Total Due: 0.00 ║ ║ ──────────────────────────────────── ║ ║ Select Option -> Print Invoice ║ ║ Print Work Order ║ ║ Redo ║ ║ Abort ║ ║ ║ ╚══════════════════════════════════════╝ ■ WORK ORDER NOTES/COMMENTS If you selected Work Order, you are given the option to edit/create any note/comment up to 21 lines long. ╔═════════════════════════════════════════════════════════════════════╗ ║ Do you wish to add any comments to the Work Order? (Y/N) ■ ║ ╚═════════════════════════════════════════════════════════════════════╝ If you select Y (Yes) to the prompt, a simple text editor will appear at center screen. Remember to keep the comment to less than 21 lines... DAYO BO, TJS LAB Page: 15 *** Note !!! Be sure to press Ctrl W to save and exit. Pressing Esc will only abort (lose) anything just typed in. *** ────────────────────────────[ WORK ORDER COMMENTS ]─────────────────────────── Send The Yellow one as soon as possible! ────────────────────────────────────────────────────────────────────────────── Esc (Exit) Ctrl W (SAVE & Exit) F1 (Help) 2/1 ■ DATABASE POSTING Database posting means the updating of all databases affected by the creation of an invoice. DAYO BO will post to 7 databases (depending on the type of invoice and configuration). The databases that get data posted to them are displayed on the top right of the screen, ie: ╔═[ Posting Progress ]════╗ ║ Invoice Header ║ ║ Invoice Detail ║ ║ Inventory Database ║ ║ Customer Database ║ ║ Salesper Database ║ ║ Serial Number Database ║ ║ BackOrder Database ║ ╚═════════════════════════╝ DAYO BO, TJS LAB Page: 16 Database Name File Name Fields Remarks ────────────────────── ──────────────── ────────────── ─────────────────── Invoice Header INVOICE.DBF All Invoice Detail DETAIL.DBF All Inventory Database INV.DBF ONHAND Onhand quantity BO BackOrdered Quantity LASTDATE Date of Last Access SOLDPTD Period to Date Sold SOLDYTD Year to Date Sold Customer Database CUSTOMER.DBF ACTIVE LASTDATE Date of Last Access SALESPTD Period to Date Sales SALESYTD Year to Date Sales PAID_PURC Total Paid DUE Total Due Salesper Database SALESPER.DBF SALESPTD Period to Date Sales SALESYTD Year to Date Sales LASTDATE Date of Last Access Serial Number Database SERIALNO.DBF All If Any... BackOrder Database BO.DBF All QTY field is adjusted ■ ADD BO RECORD To add an item/record to the BackOrder database (DB.DBF), it is highly recommended that only DAYO POS be used (create an invoice). When, for whatever reason you deem it necessary to add one (by pressing Ctrl N), remember that the invoice number must match an invoice header record in the invoice header database (INVOICE.DBF). ■ DELETE BO RECORD Press Ctrl U to delete a BO record. ■ FIND (F5/F6/F7/F8) To find a BO item, utilize the F5, F6, F7, F8 keys. Note, the use of these keys sets the order/index of the displayed records DAYO BO, TJS LAB Page: 17 ■ CUSTOMERS This menu option is a browse screen of the customer records. No editing of the database (CUSTOMER.DBF) is possible... DAYOBO V1.3, TJS LAB CUSTOMER ╔════════════════════════════════════════════════════════════════════════════╗ ║ BILL TO: SHIP TO: ║ ║ INDIA MOLRY MOLRY'S STORE ║ ║ PO BOX 382066 PO BOX 545556 ║ ║ 3449 LAKEMONT DRIVE DOOR 39 ║ ║ Lakemont, ST 55555-5555 Maryville, ST 55555-5555 ║ ║ CUSTOMER # TYPE SALESPER TERMS SHIPPER ║ ║ 1 REG TJ COD UPS GROUND ║ ║ PHONE ATTN CREDIT LASTDATE ║ ║ (800) 555-5555 Tom 394.56 01/20/90 ║ ╚═══════════════════[ View/Browse the Customer Database ]════════════════════╝ CUSTOMER NAME ATTN ───────────╥────────────────────────────────╥───────────────────────────────── 6741 ║ INDIA MOLRY ║ 17901 ║ CCS SAVINGS AND LOAN ║ 23662 ║ UNCLE SAM PINTO BEANS ║ JOSE 29673 ║ DAIRY ASSOCIATION ║ JOE 30345 ║ SALLEY MORGAN ║ 31235 ║ HERMANS COMPUTER SHOP ║ 34564 ║ HARPER TELEPHONES ║ 34565 ║ MIC, INC ║ SHELLA JONES Esc (Exit) F1 (Help) Find: F5 (Customer) F6 (Name) F7 (Ship To) F8 (Phone) F9 (Zip Code) 1/18 ■ FIND (F5/F6/F7/F8) Utilize the F5, F6, F7, F8 keys to find a customer record. Note, the use of these keys sets the order/index of the displayed records. DAYO BO, TJS LAB Page: 18 ■ CONFIGURATION DAYO BO configuration contains many configurable options that will hopefully make DAYO BO better able to meet your specific needs. There are 32+ DAYO BO configuration settings: Company Name Parallel Drawer Port Company Address Parallel Drawer Code Company Telephone Report Printer Type Auto Allocation Report Printer Port Auto Print Invoice Visual Indexing Last Invoice Number Auto Daily Indexing Invoice Printer Type Print Packing List Invoice Printer Port Packing List Port Invoice Copies Price on Packing List Allow Browse Edit Work Order Copies Use Credit Limit W.O. Printer Type Inventory Location W.O. Printer Port Customer Location W.O. Notes Phrase POS Location Open/Close Registers Cash Drawer Attached Default Comment Cash Drawer Com Port Color Parallel Cash Drawer High Intensity ■ CONFIGURATION MENU The CONFIGURATION menu is a selection box that appears on the left side of the main menu screen, ie: DAYOBO V1.3, TJS LAB CONFIG ┌────[April 1990]────┐ ╔════════════════════════╗ │S M T W T F S │ ║ CONFIGURATION ║╖ ████▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────────╢║ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ Company Name ║╢ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ Company Address ║║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ Company Telephone ║╢ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ Auto Allocation ║║ ████▀ █░ █░ █░ ▀███▀ │29 30 │ ║ Auto Print Invoice ║╢ │ │ ║ Last Invoice Number ║║ └────────────────────┘ ║ Invoice Printer Type ║╢ ║ Invoice Printer Port ║║ ║ Invoice Copies ║╢╓────────────────────────────────────────────────╖ ║ Allow Browse Edit ║║║ DAYO BO STATISTICS Register Closed ║ ║ Use Credit Limit ║╢╟────────────────────────────────────────────────╢ ║ Inventory Location ║║║ DATABASE NAME RECORDS SIZE ║ ║ Customer Location ║╝╟────────────────────────────────────────────────╢ ║ POS Location ║ ║ INV.DBF Inventory 1 1K ║ ║ Cash Drawer Attached ║ ║ INVOICE.DBF Invoice Header 0 1K ║ ║ Cash Drawer Com Port ║ ║ DETAIL.DBF Invoice Detail 0 0K ║ ║ Parallel Cash Drawer ║ ║ BACKORDER.DBF BackOrders 0 0K ║ ║ Parallel Drawer Port ║ ║ CUSTOMER.DBF Customers 1 1K ║ ╟────────────────────────╢ ║ REGISTER.LOG Register Log 90 8K ║ ║ Select Option ║ ╚════════════════════════════════════════════════╝ ╚════════════════════════╝ DAYO BO, TJS LAB Page: 19 To access any of the options (you can scroll down to others), highlight the option, then press Enter/Return. Before doing any invoicing, it is highly recommended that you read this section to get a better understanding of the meanings of every configuration setting. After determining how you wish to set/run DAYO BO, make the changes. ■ COMPANY NAME, ADDRESS & TELEPHONE Each field for these options is limited to 30 characters, 14 for the telephone... ┌──────────────────────────────[ COMPANY NAME ]─────────────────────────────┐ │ Enter Your Company Name: YOUR COMPANY NAME HERE │ └───────────────────────────────────────────────────────────────────────────┘ ┌─────────────────────────────[ COMPANY ADDRESS ]───────────────────────────┐ │ Address Line 1: Attn: Accounts Receivable │ │ Address Line 2: P.O. BOX 55555 │ │ City, State ZIP: ANYCITY, ST 55555-5555 │ └───────────────────────────────────────────────────────────────────────────┘ ┌────────────────────────────[ COMPANY TELEPHONE ]──────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └───────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATICALLY PRINT THE INVOICE ┌──────────────[ AUTOMATICALLY PRINT INVOICES AFTER INVOICING ]──────────────┐ │ If you want your invoices to automatically print after invoicing, then │ │ change this option to Y (YES). │ │ Default is to automatically print the invoices. │ │ │ │ Automatically Print Invoices? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 20 ■ AUTOMATIC ALLOCATION ┌─────────────────────[ AUTOMATIC ALLOCATION & INVOICING ]───────────────────┐ │ If this option is set to Y (YES), then no data entry prompts for │ │ serial numbers will occur at the time of Allocation (filling/ │ │ invoicing backorders). Backorders are filled, posted then invoices │ │ printed! Default is NOT to Automatically Allocate Backorders. │ │ │ │ Automatically Allocate Backorders? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST INVOICE NUMBER ┌──────────────────────────[ LAST INVOICE NUMBER ]───────────────────────────┐ │ Enter Last Invoice Number: 4999 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE PRINTER TYPE ┌──────────────────────────[ INVOICE PRINTER TYPE ]──────────────────────────┐ │ There are 3 types of DAYO BO printed invoices: STANDARD, LASER, and │ │ the DATA ONLY invoice. │ │ The STANDARD invoice prints standard characters with headings. │ │ The LASER invoice prints a special invoice onto a Hewlett Packard │ │ compatible laser printer. │ │ The DATA ONLY invoice is the same as the STANDARD with the exception │ │ of the headings (for use with pre-printed forms). │ │ │ │ Enter Your Invoice Printer Type -> STANDARD │ │ LASER │ │ DATA ONLY │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE PRINTER PORT ┌──────────────────────────[ INVOICE PRINTER PORT ]──────────────────────────┐ │ Enter Your Invoice Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVOICE COPIES ┌───────────────────[ Number of Invoice Copies To Print ]────────────────────┐ │ This option determines the number of invoice copies to print at the │ │ time of invoicing. Default is to print one copy of the invoice. │ │ │ │ Enter Number of Invoice Copies: 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 21 ■ ALLOW BROWSE EDITING ┌─────────────────────────[ ALLOW BROWSE EDITING ]───────────────────────────┐ │ To disable the editing of the BO Invoice Detail Records, select N (NO) │ │ to this option. Default is to allow it. │ │ │ │ Allow Editing of BO Invoice Detail Records? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ USE CREDIT LIMIT ┌────────────────────────────[ USE CREDIT LIMIT ]────────────────────────────┐ │ If you wish to place credit limits on your customers, then set this │ │ option to Y (YES). Default is N (NO). If set to Y, then no 'Net' │ │ sales/invoice can be made if that invoice amount plus the amount due │ │ on other sales is greater than the customers credit limit. The credit │ │ limit is the value of the LIMIT field in the customer database │ │ (CUSTOMER.DBF). │ │ │ │ Limit Credit? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY DATABASE LOCATION ┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐ │ The location of the DAYO Inventory (INV.DBF) does not have to be in │ │ the same drive/directory as DAYO BO. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO BO where to find the │ │ inventory database (INV.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYO\ │ │ The drive designation is optional (if same as DAYO BO). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CUSTOMER DATABASE LOCATION ┌─────────────────[ CUSTOMER DATABASE LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Customer file (CUSTOMER.DBF) does not have to be │ │ in the same drive/directory as DAYO BO. If you have installed the DAYO │ │ Customer Database (CUSTOMER.DBF), into a different directory, you need │ │ to tell DAYO BO where to find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAR\ │ │ The drive designation is optional (if same as DAYO BO). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 22 ■ POS DATABASE LOCATION For DAYO BO to function, it requires the use of the DAYO POS invoice databases (INVOICE.DBF & DETAIL.DBF) as well as the common databases (ie, TERMS, TYPE, TAXCODE, SHIPPER, REGISTER). If DAYO BO is not installed into the same drive/directory as DAYO POS, then insure that the location of DAYO POS is correctly entered: ┌─────────────────────[ POS DATABASE LOCATION/DIRECTORY ]────────────────────┐ │ The location of the DAYO POS Invoice files (INVOICE.DBF & DETAIL.DBF) │ │ does not have to be in the same drive/directory as DAYO BO. If you have │ │ installed the DAYO POS Databases into a different directory, you need │ │ to tell DAYO BO where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPOS\ │ │ The drive designation is optional (if same as DAYO BO). │ │ │ │ Enter Location: \DAYOPOS\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CASH DRAWER ┌──────────────────────────────[ CASH DRAWER ]───────────────────────────────┐ │ The default for DAYO BO is that a cash drawer is NOT attached. │ │ The type of cash drawer that works with DAYO BO connects via the │ │ serial port. It will open when a signal is sent to it via the │ │ communications port (COM1:, COM2:, or COM3:). │ │ Note, an error will occur if you set this to Y (Yes), and you │ │ do not have a cash drawer attached. │ │ │ │ Do you have a cash drawer attached? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ CASH DRAWER SERIAL PORT ┌────────────────────────[ CASH DRAWER SERIAL PORT ]─────────────────────────┐ │ Enter Your Cash Drawer Serial Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PARALLEL CASH DRAWER ┌──────────────────────────[ PARALLEL CASH DRAWER ]──────────────────────────┐ │ The default for DAYO BO is that a parallel cash drawer is NOT attached. │ │ The parallel cash drawer connects via the parallel/printer port: LPT1, │ │ LPT2, or LPT3. It will open when a signal (Setup Code), is sent to it │ │ at invoice time. │ │ Note, an error will occur if you set this to Y (Yes), and you │ │ do not have a cash drawer attached, or have it off/offline. │ │ │ │ Do you have a parallel cash drawer attached? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 23 ■ PARALLEL CASH DRAWER PORT ┌───────────────────────[ PARALLEL CASH DRAWER PORT ]────────────────────────┐ │ Enter Your Cash Drawer Parallel Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PARALLEL CASH DRAWER SETUP CODE ┌────────────────────[ PARALLEL CASH DRAWER SETUP CODE ]─────────────────────┐ │ If you have a parallel cash drawer, it is required that some character │ │ string (setup code), be sent as a signal to the cash drawer instructing │ │ it to open. When entering the setup code, you must enter a valid │ │ character string in the format: 'OPEN SAYS ME' or 'CHR(1)+CHR(1)' │ │ Check your cash drawer manual for the correct Setup Code! │ │ │ │ Enter Your Cash Drawer Parallel Setup Code On The Next Line: │ │ Setup Code: CHR(1)+CHR(1) │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER TYPE ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VISUAL INDEXING ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). Note, the process can slow the indexing │ │ routine down; especially with larger databases. │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 24 ┌──────────────────────────────────────────────────────────┐ │ Database Name: DETAIL.DBF │ │ Index Name: DETITEM.NTX │ │ Number of Records: 394 │ │ ┌──────────────────────────────────────────────────┐ │ │ │████████████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ ■ AUTOMATIC DAILY INDEXING ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO BO will be recreated once daily. This will occur when the first │ │ DAYO BO program is run. The default is to recreate all the indexes. │ │ │ │ Recreate all DAYO BO Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ The DAYO Indexing program (DAYOX) was created for this purpose. ■ AUTO PRINT PACKING LIST ┌────────────[ AUTOMATICALLY PRINT PACKING LIST AFTER INVOICING ]────────────┐ │ If you want a packing list to print automatically after invoicing, then │ │ change this option to Y (YES). │ │ Default is not to print packing lists. │ │ │ │ Automatically Print Packing Lists? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ PACKING LIST PRINTER PORT ┌───────────────────────[ PACKING LIST PRINTER PORT ]────────────────────────┐ │ Enter Your Packing List Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT PRICE ON PACKING LIST ┌────────────────────[ PRINT PRICE ON THE PACKING LIST ]─────────────────────┐ │ If you want to print the PRICE on the packing list, the set this option │ │ to Y (YES). Default is NOT to print the price on the packing lists. │ │ │ │ Print Price On The Packing List? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 25 ■ WORK ORDER COPIES ┌──────────────────[ Number of Work Order Copies To Print ]──────────────────┐ │ This option determines the number of Work Order copies to print at the │ │ time of invoicing. Default is to print one copy of the work order. │ │ │ │ Enter Number of Work Order Copies: 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ WORK ORDER PRINTER TYPE ┌────────────────────────[ WORK ORDER PRINTER TYPE ]─────────────────────────┐ │ Work Orders are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Work Order Printer Type -> STANDARD │ │ LASER │ │ PREPRINTED │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ WORK ORDER PRINTER PORT ┌────────────────────────[ WORK ORDER PRINTER PORT ]─────────────────────────┐ │ Enter Your Work Order Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ WORK ORDER NOTES PHRASE ┌─────────────────────────[ WORK ORDER NOTE PHRASE ]─────────────────────────┐ │ This 'Phrase' or 'Leading Comment' is printed at the beginning of all │ │ Work Order Notes/Comments. Examples are 'Shipping Instructions:', │ │ 'Notes:' or 'Special Instructions:' │ │ Default is not to print anything! │ │ │ │ Enter Work Order Notes Phrase: Shipping Instructions: │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 26 ■ USE REGISTERS ┌──────────────────────────[ OPEN/CLOSE REGISTERS ]──────────────────────────┐ │ This option determines whether the prompt to open and/or close the │ │ registers is activated. Default (Yes) is to require that you │ │ open/close the registers. │ │ │ │ Open/Close Registers? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT COMMENT ┌────────────────────────────[ DEFAULT COMMENT ]─────────────────────────────┐ │ This comment is printed onto every Invoice and Work Order. │ │ │ │ Enter Default Comment: Thank You! │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, high intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 28 ■ REPORTS The REPORTS menu contains 5 reports, many with different options and a printer setup/driver routine. Note that other reports can be created using dBase III+/IV as well as other compatible report writers. Use the DAYO POS module to print out Register Reports. The MISC Routines even has the LIST function in it that allows the creation of simple lists/reports... All the reports can be printed to the printer, or to a text/ASCII file. The Reports menu: ╔═════════════════════════════╗ ║ DAYO BACK ORDER REPORTS ║ ║ Allocation Report ║ ║ Back Order Report ║ ║ Inventory Reset & Report ║ ║ Customer Address Labels ║ ║ Config Status ║ ║ Printer Setup ║ ║ SELECT REPORT ║ ╚═════════════════════════════╝ The Allocation, BackOrder, and the Inventory (BO) Reports all use a 'report form'. These report forms all have the extension of '.FRM', and are dBase (tm) compatible. Report Form Uses Name Database ────────────── ─────────────── ALLOCATE.FRM ALLOCATE.DBF BO.FRM BO.DBF CUSTOMER.DBF INVOICE.DBF BORESET.FRM BO.DBF INV.DBF DAYO BO, TJS LAB Page: 29 ■ ALLOCATION REPORT ╔═══════════════════════════════════════════════════════╗ ║The Allocation Report lists all BackOrdered items ║ ║that were allocated/'filled' during the last ║ ║Allocation Process. Uses Report Form: ALLOCATE.FRM ║ ║ ║ ║Select Index -> INVOICE+ITEM ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: ALLOCATE.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ ■ BACK ORDER REPORT This report has the option to all BackOrders, or for a specific customer. ╔═══════════════════════════════════════════════════════╗ ║The Detail Back Order Report lists all BackOrdered ║ ║items that exist in the BackOrder Database (BO.DBF). ║ ║Uses Report Form: BO.FRM. ║ ║ ║ ║Print Entire Report... ║ ║ ║ ║Select Index -> ITEM ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: BO.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ╚═══════════════════════════════════════════════════════╝ DAYO BO, TJS LAB Page: 30 ■ INVENTORY BACKORDER RESET & REPORT This report routine can optionally reset/recalculate the BO (back order) field in the inventory database (INV.DBF). It is recommended that this option be run anytime there is a question about the accuracy of the BO field. ╔═══════════════════════════════════════════════════════╗ ║The Inventory BackOrder Reset & Report will ║ ║optionally reset the BackOrder field (BO) in the ║ ║Inventory database (INV.DBF), then print a list ║ ║containing all inventory line items that have ║ ║Sales Order BackOrders ( BO > 0 ). ║ ║Uses Report Form: BORESET.FRM. ║ ║ ║ ║Will reset the BackOrder field! ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: BORESET.TXT ║ ║ ║ ║Enter Report Title: TJS LAB ║ ║ ║ ║Inventory File Zero Reset Process (Pass 1) ║ ║╞█████████████████████████████████████████████████████╡║ ║ ║ ║Inventory File BackOrder Reset Process (Pass 2) ║ ║╞███████████████████████████████████══════════════════╡║ ╚═══════════════════════════════════════════════════════╝ ■ CUSTOMER SHIP TO ADDRESS LABELS This report option prints out labels containing the Ship To address of the customer/client. Find the customer/client you want to create a label for, then press Enter/Return. Press Enter/Return for as many labels you desire. To assist you in locating a customer/client, the FIND function keys F5, F6, F7, and F8 are available. ╔═══════════════════════════════════════════════════════╗ ║Use this option to print the Customer SHIP TO address ║ ║Labels. The Address Label is the standard size of ║ ║ 3.5x15/16, 6LPI, and contains the following fields: ║ ║ SHIPNAME SHIPPADDR1 SHIPADDR2 ║ ║ SHIPCITY SHIPSTATE SHIPZIP ║ ║ ║ ║ ┌──────────────────────────────┐ ║ ║ │JOSE L MARTINEZ │ ║ ║ │90 VEEGE │ ║ ║ │MEXICO CITY, MEXICO │ ║ ║ │ │ ║ ║ │ │ ║ ║ ╘══════════════════════════════╛ ║ ║ CUSTOMER ║ ║Select Customer -> 3444 ║ ║ 3445 ║ ║ 3446 ║ ║Esc (Exit) Enter/Return (Print) F5/F6/F7/F8 (Find) ║ ╚═══════════════════════════════════════════════════════╝ DAYO BO, TJS LAB Page: 31 ■ DATABASE STATUS REPORT This report prints out the structure, number of records and sizes of all major DAYO BO database. This report does not use a report form. Like the TEMPLATE Report, this one only gives you the option to print to the printer or to a disk file, ie: ╔═══════════════════════════════════════════════════════╗ ║The Database Status Report lists the DAYO BO ║ ║databases with their current fields, sizes and number ║ ║of records. Index files included. Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: DATABASE.TXT ║ ╚═══════════════════════════════════════════════════════╝ An example of a Database Status Report follows. Note, only one database is listed (there are more!): ++++++++++++++++++++++++ + DAYO DATABASE REPORT + ++++++++++++++++++++++++ 12/28/89 22:14:39 Inventory Database: \DAYOINV\INV.DBF Number of Records: 74 File Size: 13,138 FIELD NAME TYPE LENGTH DECIMALS ============ ==== ====== ======== ITEM C 12 0 DESC C 30 0 ONHAND N 7 0 ONORDER N 7 0 SOLDPTD N 7 0 SOLDYTD N 7 0 VENDITEM C 12 0 VENDOR C 10 0 DATE D 8 0 LASTDATE D 8 0 COST N 10 2 RETAIL N 10 2 PRICE N 10 2 STOCKLEVEL N 7 0 DAYO BO, TJS LAB Page: 32 Database Status Report Continuation... TYPE C 3 0 CLASS C 3 0 TAXABLE L 1 0 SERIALNO L 1 0 WEIGHT N 8 2 UNIT C 3 0 LOCATION C 3 0 ====== 167 Index Files: INV.NTX Index Key: ITEM DESC.NTX Index Key: DESC VENDOR.NTX Index Key: VENDOR VENDITEM.NTX Index Key: VENDITEM INVTYPE.NTX Index Key: TYPE ■ CONFIGURATION STATUS REPORT The Configuration Status Report is just a list of the current configuration settings. It is not a report form. The only option is to print it to a printer or to a disk file, ie: ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOBO.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO BO, TJS LAB Page: 33 ++++++++++++++++++++++++++++++++++++++++++ + DAYO BACK ORDER CONFIGURATION REPORT + ++++++++++++++++++++++++++++++++++++++++++ 04/07/90 20:57:20 Company Name: YOUR COMPANY, INC Address Line 1: Attn: Accounts Receivable Address Line 2: P.O. BOX 5555 City, State Zip: ANYCITY, ST 55555-5555 Telephone: 800-555-5555 Auto Allocation: No Auto Print Invoice: Yes Last Invoice Number: 0 Invoice Printer Type: STANDARD Invoice Printer Port: LPT1 Number of Invoice Copies: 1 Default Tax Code: 1 Default Invoice Type: STANDARD Allow Negative Onhand: No Allow Editing In Browse: Yes Use Credit Limits: Yes Inventory Database Location: Customer Database Location: POS Database Location: Serial Cash Drawer Attached: No Serial Cash Drawer Com Port: COM1 Parallel Cash Drawer: No Parallel Cash Drawer Port: LPT1 Parallel Cash Drawer Code: CHR(1)+CHR(1) Report Printer Type: LASER PRINTER Report Printer Port: LPT1 Visual Indexing: Yes Automatically Reindex Daily: Yes Auto Print Packing List: No Packing List Printer Port: LPT1 Color: Yes High Intensity: Yes DAYO BO, TJS LAB Page: 34 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change (mess with) the printer to get it to print correctly. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO BO, TJS LAB Page: 35 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO BO, TJS LAB Page: 36 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set lazer printer to print upright (normal) LANDSCAPE - Code to set lazer printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO BO, TJS LAB Page: 37 ■ HELP SCREENS - While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. - BROWSE help: ┌──────────────────────[ DAYOBO HELP: DBEDIT, 0, ]──────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ - Option Box Help: ┌───────────────────────[ DAYOBO HELP: ACHOICE, 0, ]────────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO BO, TJS LAB Page: 38 - Editor help: ┌──────────────────────[ DAYOBO HELP: MEMOEDIT, 0, ]────────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). DAYO BO, TJS LAB Page: 39 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYOPAY V1.3, TJS LAB ┌────[August 1990]───┐ ┌──────[ DAYO HELP Called by Program: DAYOPAY Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOPAY. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO BO, TJS LAB Page: 40 DAYOPAY V1.3, TJS LAB ┌────[August 1990]──┐ ┌───────[ DAYO HELP Called by Program: DAYOPAY Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOPAY the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE: 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO BO, TJS LAB Page: 41 ■ DATABASE STRUCTURE Database: BO.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 ITEM Character 12 7 18 3 DESC Character 30 19 48 4 QTY Numeric 7 49 55 5 PRICE Numeric 10 2 56 65 6 COST Numeric 10 2 66 75 7 TAXABLE Logical 1 76 76 8 DATE Date 8 77 84 9 PAY Logical 1 85 85 10 TIME Character 8 86 93 ───── Total 94 DAYO BO, TJS LAB Page: 42 Database: CUSTOMER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CUSTOMER Numeric 6 1 6 2 NAME Character 30 7 36 3 ATTN Character 30 37 66 4 ADDR1 Character 30 67 96 5 ADDR2 Character 30 97 126 6 CITY Character 22 127 148 7 STATE Character 2 149 150 8 ZIP Character 10 151 160 9 SHIPNAME Character 30 161 190 10 SHIPADDR1 Character 30 191 220 11 SHIPADDR2 Character 30 221 250 12 SHIPCITY Character 22 251 272 13 SHIPSTATE Character 2 273 274 14 SHIPZIP Character 10 275 284 15 PHONE Character 14 285 298 16 SALESPER Character 3 299 301 17 TAXRATE Numeric 5 3 302 306 18 TERMS Character 20 307 326 19 SHIPPER Character 20 327 346 20 DATE Date 8 347 354 21 LASTDATE Date 8 355 362 22 TYPE Character 3 363 365 23 CLASS Character 3 366 368 24 PBM Numeric 6 3 369 374 25 PBL Numeric 6 3 375 380 26 SALESPTD Numeric 10 2 381 390 27 SALESYTD Numeric 10 2 391 400 28 DUE Numeric 10 2 401 410 29 PAID_PURC Numeric 10 2 411 420 30 LIMIT Numeric 10 2 421 430 31 ACTIVE Logical 1 431 431 ───── Total 432 DAYO BO, TJS LAB Page: 43 Database: INVOICE.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 CUSTOMER Numeric 6 7 12 3 SHIPNAME Character 30 13 42 4 SHIPADDR1 Character 30 43 72 5 SHIPADDR2 Character 30 73 102 6 SHIPCITY Character 17 103 119 7 SHIPSTATE Character 2 120 121 8 SHIPZIP Character 10 122 131 9 PHONE Character 14 132 145 10 TYPE Character 3 146 148 11 TERMS Character 20 149 168 12 SHIPPER Character 20 169 188 13 DATE Date 8 189 196 14 TIME Character 8 197 204 15 REG Character 3 205 207 16 BY Character 30 208 237 17 SALESPER Character 3 238 240 18 CUST_PO Character 15 241 255 19 TAXRATE Numeric 5 3 256 260 20 TAXES Numeric 10 2 261 270 21 ADJUST Numeric 10 2 271 280 22 FREIGHT Numeric 10 2 281 290 23 SUBTOTAL Numeric 10 2 291 300 24 OPEN Logical 1 301 301 25 PAID Numeric 10 2 302 311 26 COMMENT Character 50 312 361 27 PRINTED Logical 1 362 362 28 BO Numeric 6 363 368 29 SC Logical 1 369 369 ───── Total 370 Database: DETAIL.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 INVOICE Numeric 6 1 6 2 ITEM Character 12 7 18 3 DESC Character 30 19 48 4 QTY Numeric 7 49 55 5 PRICE Numeric 10 2 56 65 6 COST Numeric 10 2 66 75 7 TAXABLE Logical 1 76 76 8 DATE Date 8 77 84 9 CLASS Character 3 85 87 ───── Total 88 DAYO BO, TJS LAB Page: 44 Database: INV.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 DESC Character 30 13 42 3 ONHAND Numeric 7 43 49 4 ONORDER Numeric 7 50 56 5 BO Numeric 7 57 63 6 SOLDPTD Numeric 7 64 70 7 SOLDYTD Numeric 7 71 77 8 VENDITEM Character 12 78 89 9 VENDOR Character 10 90 99 10 DATE Date 8 100 107 11 LASTDATE Date 8 108 115 12 COST Numeric 10 2 116 125 13 RETAIL Numeric 10 2 126 135 14 PRICE Numeric 10 2 136 145 15 STOCKLEVEL Numeric 7 146 152 16 TYPE Character 3 153 155 17 CLASS Character 3 156 158 18 TAXABLE Logical 1 159 159 19 SERIALNO Logical 1 160 160 20 WEIGHT Numeric 8 2 161 168 21 UNIT Character 3 169 171 22 LOCATION Character 3 172 174 ───── ────────── ───────── ───── ─── ───── ─── Total 175 Database: REGISTER.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 OPEN Logical 1 1 1 2 OPENDATE Date 8 2 9 3 OPENTIME Character 8 10 17 4 CLOSEDATE Date 8 18 25 5 CLOSETIME Character 8 26 33 6 STARTSUM Numeric 10 2 34 43 7 ENDSUM Numeric 10 2 44 53 8 BY Character 30 54 83 ───── Total 84 DAYO BO, TJS LAB Page: 45 Database: REGISTER.LOG Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 REGISTER Numeric 3 1 3 2 OPENCLOSE Character 1 4 4 3 OPENDATE Date 8 5 12 4 OPENTIME Character 8 13 20 5 CLOSEDATE Date 8 21 28 6 CLOSETIME Character 8 29 36 7 STARTSUM Numeric 10 2 37 46 8 ENDSUM Numeric 10 2 47 56 9 BY Character 30 57 86 ───── Total 87 Database: SERIALNO.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 INVOICE Numeric 6 13 18 3 SERIALNO Character 30 19 48 4 CUSTOMER Numeric 6 49 54 5 DATE Date 8 55 62 ───── Total 63 DAYO BO, TJS LAB Page: 46 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ACTIVE L 1 0 CUSTOMER.DBF Denotes customer as being Active ADDR1 C 30 0 CUSTOMER.DBF Customer Bill To address line 1 ADDR2 C 30 0 CUSTOMER.DBF Customer Bill To address line 2 ADJUST N 10 2 INVOICE.DBF Amount of Adjustment ($) ATTN C 30 0 CUSTOMER.DBF Customer contact (POC) name BO N 6 0 INVOICE.DBF Original Invoice number BO N 7 0 INV.DBF BackOrdered quantity BY C 30 0 REGISTER.LOG User responsible for opening or REGISTER.DBF closing the register INVOICE.DBF User that created the invoice CITY C 22 0 CUSTOMER.DBF Customer Bill To city CLASS C 3 0 INV.DBF Items classification CUSTOMER.DBF Customers classification CLOSEDATE D 8 0 REGISTER.LOG Date register closed REGISTER.DBF CLOSETIME C 8 0 REGISTER.DBF Time register closed REGISTER.LOG COMMENT C 50 0 INVOICE.DBF Comment to appear onto the invoice when it is printed COST N 10 2 INV.DBF Cost (from Vendor) of an item DETAIL.DBF BO.DBF CUSTOMER N 6 0 SERIALNO.DBF Customer number INVOICE.DBF CUSTOMER.DBF CUST_PO C 15 0 INVOICE.DBF Customers Purchase Order number DATE D 8 0 DETAIL.DBF Date record was created SERIALNO.DBF INV.DBF BO.DBF INVOICE.DBF CUSTOMER.DBF DESC C 30 0 BO.DBF Description of an item DETAIL.DBF INV.DBF DUE N 10 2 CUSTOMER.DBF Amount the customer owes your company (Accounts Receivable) ENDSUM N 10 2 REGISTER.LOG Closing total of dollars received REGISTER.DBF into a register FREIGHT N 10 2 INVOICE.DBF Amount of freight charged ($) DAYO BO, TJS LAB Page: 47 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── INVOICE N 6 0 INVOICE.DBF Invoice Number SERIALNO.DBF BO.DBF DETAIL.DBF ITEM C 12 0 INV.DBF Product/Part/Item number BO.DBF DETAIL.DBF SERIALNO.DBF LASTDATE D 8 0 CUSTOMER.DBF Last Date Accessed INV.DBF LIMIT N 10 2 CUSTOMER.DBF Credit Limit for the customer LOCATION C 3 0 INV.DBF Bin or physical location of an item in the inventory 'warehouse' NAME C 30 0 CUSTOMER.DBF Customers Bill To name ONHAND N 7 0 INV.DBF Quantity of an item that is physically in the inventory ONORDER N 7 0 INV.DBF Quantity on Purchase Order from a Vendor OPEN L 1 0 REGISTER.DBF Register is open/closed INVOICE.DBF Invoice is open/closed (A/R) OPENCLOSE C 1 0 REGISTER.LOG Used to determine if register is opened or closed OPENDATE D 8 0 REGISTER.DBF Date register was opened REGISTER.LOG OPENTIME C 8 0 REGISTER.DBF Time register was opened REGISTER.LOG PAID N 10 2 INVOICE.DBF Amount received from the customer as payment on the invoice PAID_PURC N 10 2 CUSTOMER.DBF Total amount of receipts from the customer for all open orders PAY L 1 0 BO.DBF Flag to denote whether the BackOrdered item has been paid for in advance PBL N 6 3 CUSTOMER.DBF Price Book List Factor PBM N 6 3 CUSTOMER.DBF Price Book Margin Factor PHONE C 14 0 CUSTOMER.DBF Customers telephone number INVOICE.DBF PRICE N 10 2 BO.DBF Price of item to the customer INV.DBF DETAIL.DBF PRINTED L 1 0 INVOICE.DBF Flag to denote that an invoice has been printed DAYO BO, TJS LAB Page: 48 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── QTY N 7 0 BO.DBF Quantity BackOrdered DETAIL.DBF Quantity Invoiced REG C 3 0 INVOICE.DBF Register number REGISTER N 3 0 REGISTER.LOG Register number RETAIL N 10 2 INV.DBF Manufacturer recommended Retail/List price SALESPER C 3 0 CUSTOMER.DBF Sales Person to get credit for INVOICE.DBF the sale SALESPTD N 10 2 CUSTOMER.DBF Period to Data sales SALESYTD N 10 2 CUSTOMER.DBF Year to Data sales SC L 1 0 INVOICE.DBF Ship Complete flag SERIALNO C 30 0 SERIALNO.DBF Serial number SERIALNO L 1 0 INV.DBF Serial number required flag SHIPADDR1 C 30 0 INVOICE.DBF Ship To address line 1 CUSTOMER.DBF SHIPADDR2 C 30 0 INVOICE.DBF Ship To address line 2 CUSTOMER.DBF SHIPCITY C 22 0 CUSTOMER.DBF Ship To city SHIPCITY C 17 0 INVOICE.DBF Ship To city SHIPNAME C 30 0 INVOICE.DBF Ship To name CUSTOMER.DBF SHIPPER C 20 0 INVOICE.DBF Shipper or Method of Shipment CUSTOMER.DBF SHIPSTATE C 2 0 INVOICE.DBF Ship To state CUSTOMER.DBF SHIPZIP C 10 0 INVOICE.DBF Ship To zip CUSTOMER.DBF SOLDPTD N 7 0 INV.DBF Quantity sold Period to Date SOLDYTD N 7 0 INV.DBF Quantity sold Year to Date STARTSUM N 10 2 REGISTER.DBF Amount of money that a register REGISTER.LOG started with STATE C 2 0 CUSTOMER.DBF Bill To state STOCKLEVEL N 7 0 INV.DBF Inventory stockage level SUBTOTAL N 10 2 INVOICE.DBF Total of invoice detail line items TAXABLE L 1 0 DETAIL.DBF Charge tax flag INV.DBF BO.DBF TAXES N 10 2 INVOICE.DBF Total amount of invoice taxes TAXRATE N 5 3 INVOICE.DBF Tax rate CUSTOMER.DBF TERMS C 20 0 CUSTOMER.DBF Terms of payment for an invoice INVOICE.DBF ie: CASH, CHECK, NET 30 DAYO BO, TJS LAB Page: 49 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── TIME C 8 0 BO.DBF Time record was created INVOICE.DBF TYPE C 3 0 CUSTOMER.DBF Type of customer INV.DBF Type of inventory item INVOICE.DBF Type of invoice UNIT C 3 0 INV.DBF Unit of issue, ie: EA, BOX, KIT VENDITEM C 12 0 INV.DBF Vendor/Manufacturer Item/Part/ Product number VENDOR C 10 0 INV.DBF Vendor number/code WEIGHT N 8 2 INV.DBF Weight of 1 each item ZIP C 10 0 CUSTOMER.DBF Bill To zip DAYO BO, TJS LAB Page: 50 ■ DAYO BO MAINTENANCE & QUIRKS - After using DAYO BO for any period of time, you will need to 'clean out' deleted and closed invoices (INVOICE.DBF, DETAIL.DBF), BackOrder (BO.DBF), and Register (REGISTER.LOG), records/entries. This task can be accomplished with the DAYO End of Period program (DAYO EOP), but if you are not using it, then you will have to use the DAYO POS MISC ROUTINES to DELETE, then PACK the databases. This task is often called the 'End of Month' (EOM), or 'End of Period' (EOP) purge. The period may be daily, weekly, monthly, quarterly, or yearly. Deleted records should remain in their respected databases until this time to allow for organized record keeping. At this time, reports covering the period could be printed as well as backups of the databases being made. The backup is especially important since you will be permanently removing the records with the PACK option in the MISC routines. - At EOM/EOP time, the SOLDPTD field in the inventory database (INV.DBF), the SALESPTD field in the customer and sales persons database (CUSTOMER.DBF & SALESPER.DBF), should be set to zero. Note that these fields are maintained/ adjusted by the use of the Inventory Adjustments option in the inventory browse screen, and by using DAYO BO. - On occasion (maybe an under statement), index files will get corrupted, especially on networks. To 'fix' a corrupted index requires that everyone 'get out of' the DAYO databases, and then perform a reindexing (actually a recreation of the indexes). The reindex is accomplished by running the DAYO BO program with a parameter of 'INDEX' (or using DAYO X). ie: C:\>DAYOO INDEX - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - Indexes are recreated once every day. This is automatically performed by the first user to run DAYO BO. This process will take more time as your files get larger. This process should take place daily, but you can run it at night with a batch file that waits until after midnight (ie: DAYO Clock), or a with most scheduling programs. All other users and computers must be out of the databases, or the procedure will not occur properly. Remember to 'flag' the files sharable, readable and writable. DAYO BO, TJS LAB Page: 51 - Backups of your data and configuration files should take place daily! You have no doubt heard many scare stories. They are all true! The key files that need to be backed up, all have the extension of .DBF, and .CFG. The .DBF files are your databases. The .CFG is the file that contains your configuration information (as seen in the Configuration module). - If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. - If you must use dBase (tm) with DAYO BO, and you are on a PC based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... DAYO BO, TJS LAB Page: 52 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and some Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $35.00 per hour (our sites). Guarantees for quality and timely work is our number one rule ('Do it now, do it right, do it cheap!'). We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or use our voice mail/answering machine (24 hours/day) * (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered Shareware products.